package com.fowo.api.model.batch.details;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.common.excel.ImageConvert;
import com.fowo.api.sys.entity.SysFile;
import java.util.List;
import javax.validation.constraints.*;
import lombok.Getter;
import lombok.Setter;

/** 批次明细 导入导出辅助模型 */
@Getter
@Setter
public class BatchDetailsExcelPo {

  @Size(max = 50, message = "批次号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "批次号")
  private String batchNum;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "入库类型")
  private String type;

  @Size(max = 50, message = "品名长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "品名")
  private String tradeNameName;

  @ExcelIgnore
  @ExcelProperty(value = "品名")
  private Long tradeName;

  @Size(max = 50, message = "SKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "SKU")
  private String sku;

  @Size(max = 50, message = "店铺长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "店铺")
  private String shopShopName;

  @ExcelIgnore
  @ExcelProperty(value = "店铺")
  private Long shop;

  @Size(max = 50, message = "MSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "MSKU")
  private String msku;

  @Size(max = 50, message = "FNSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "FNSKU")
  private String fnsku;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "仓库")
  private String wareHouseName;

  @ExcelIgnore
  @ExcelProperty(value = "仓库")
  private Long wareHouse;

  @Size(max = 50, message = "源头批次号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "源头批次号")
  private String sourceBatchNumber;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "入库单据")
  private String inboundDocumentsOrderSn;

  @DateTimeFormat("yyyy年MM月dd日HH:mm:ss")
  @ExcelProperty(value = "操作时间")
  private java.util.Date operationTime;

  @DateTimeFormat("yyyy年MM月dd日HH:mm:ss")
  @ExcelProperty(value = "入库时间")
  private java.util.Date inboundTime;

  @Size(max = 50, message = "图片长度不能超过20")
  @ExcelProperty(value = "图片", converter = ImageConvert.class)
  private List<SysFile> img;

  @Size(max = 50, message = "国家（地区）长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "国家（地区）")
  private String countryName;

  @ExcelIgnore
  @ExcelProperty(value = "国家（地区）")
  private Long country;

  @ExcelProperty(value = "总数")
  private Integer total;

  @ExcelProperty(value = "在途量")
  private Integer inTransit;

  @ExcelProperty(value = "在库量")
  private Integer amountInStock;

  @ExcelProperty(value = "可用在途量")
  private Integer availableInTransit;

  @ExcelProperty(value = "次品在途量")
  private Integer defectiveProductsInTransit;

  @ExcelProperty(value = "待检量")
  private Integer amountInspected;

  @ExcelProperty(value = "可用量")
  private Integer availableAmount;

  @ExcelProperty(value = "次品量")
  private Integer defectiveQuantity;

  @ExcelProperty(value = "采购单价")
  private java.math.BigDecimal purchaseUnitPrice;

  @ExcelProperty(value = "单位费用")
  private java.math.BigDecimal unitCosts;

  @ExcelProperty(value = "单位头程")
  private java.math.BigDecimal unitHeadStroke;

  @ExcelProperty(value = "单位库存成本")
  private java.math.BigDecimal unitInventoryCost;

  @ExcelProperty(value = "货值")
  private java.math.BigDecimal goodsValue;

  @ExcelProperty(value = "费用")
  private java.math.BigDecimal expenses;

  @ExcelProperty(value = "头程")
  private java.math.BigDecimal headStroke;

  @ExcelProperty(value = "库存成本")
  private java.math.BigDecimal inventoryCost;

  @Size(max = 50, message = "采购计划长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "采购计划")
  private String procurementPlanningPpgSn;

  @ExcelIgnore
  @ExcelProperty(value = "采购计划")
  private Long procurementPlanning;

  @Size(max = 50, message = "采购单长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "采购单")
  private String purchaseOrderPurchaseOrderCode;

  @ExcelIgnore
  @ExcelProperty(value = "采购单")
  private Long purchaseOrder;

  @Size(max = 50, message = "收货单长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "收货单")
  private String goodsReceiptOrderSn;

  @ExcelIgnore
  @ExcelProperty(value = "收货单")
  private Long goodsReceipt;

  @Size(max = 50, message = "供应商长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "供应商")
  private String supplierSupplierName;

  @ExcelIgnore
  @ExcelProperty(value = "供应商")
  private Long supplier;

  @Size(max = 50, message = "在库库龄长度不能超过20")
  @ExcelProperty(value = "在库库龄")
  private Integer ageInTheLibrary;
}
